package co.gov.medellin.ssti.sub.model.dao;

import java.sql.SQLException;
import java.util.Collection;
import java.util.List;

import co.gov.medellin.ssti.sub.model.dao.exception.DAOException;
import co.gov.medellin.ssti.sub.model.vo.SedeVO;
import co.gov.medellin.ssti.sub.model.vo.UsuarioxSedeVO;

public interface ISedeDAO extends BaseDAO {

	/**
	 * 
	 * @return
	 * @throws SQLException
	 */
	List<SedeVO> loadAllSedes() throws DAOException;

	Collection<UsuarioxSedeVO> findUsuarioxSede(UsuarioxSedeVO criterea)
			throws DAOException;

	Collection<SedeVO> findSedes(String nombreSede) throws DAOException;

	String findNameByCode(String strCodeSede) throws DAOException;

	Collection<SedeVO> findTotalSedebyUser(Long codeUser, Long codeSubpro,
			String groupUserName, Long areaUser) throws DAOException;

	Collection<SedeVO> findTotalSedebyUser(Long codeUser, Long codeSubpro,
			String groupUserName, Long areaUser, String codeSede)
			throws DAOException;

	Collection<SedeVO> findSedesAsociadas(String codeSub) throws DAOException;

	Collection<SedeVO> findSedes() throws DAOException;
}
